package com.reguang.common.config;

import java.sql.SQLException;

import javax.sql.DataSource;

import org.springframework.beans.factory.annotation.Value;
import org.springframework.boot.autoconfigure.jdbc.DataSourceProperties;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.web.servlet.FilterRegistrationBean;
import org.springframework.boot.web.servlet.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;

import lombok.extern.slf4j.Slf4j;

/**
 * 
 * <p>Title: DruidDBConfig</p>
 * <p>Description: JDBC配置</p>
 * @author weibiao
 * @date 2020年1月8日
 */
//@Configuration
//@Slf4j
public class DruidDBConfig {

//	@Value("${spring.datasource.url}")
//	private String dbUrl;
//
//	@Value("${spring.datasource.username}")
//	private String username;
//
//	@Value("${spring.datasource.password}")
//	private String password;
//
//	@Value("${spring.datasource.driverClassName}")
//	private String driverClassName;
//
//	@Value("${spring.datasource.initialSize}")
//	private int initialSize;
//
//	@Value("${spring.datasource.minIdle}")
//	private int minIdle;
//
//	@Value("${spring.datasource.maxActive}")
//	private int maxActive;
//
//	@Value("${spring.datasource.maxWait}")
//	private int maxWait;
//
//	@Value("${spring.datasource.timeBetweenEvictionRunsMillis}")
//	private int timeBetweenEvictionRunsMillis;
//
//	@Value("${spring.datasource.minEvictableIdleTimeMillis}")
//	private int minEvictableIdleTimeMillis;
//
//	@Value("${spring.datasource.validationQuery}")
//	private String validationQuery;
//
//	@Value("${spring.datasource.testWhileIdle}")
//	private boolean testWhileIdle;
//
//	@Value("${spring.datasource.testOnBorrow}")
//	private boolean testOnBorrow;
//
//	@Value("${spring.datasource.testOnReturn}")
//	private boolean testOnReturn;
//
//	@Value("${spring.datasource.poolPreparedStatements}")
//	private boolean poolPreparedStatements;
//
//	@Value("${spring.datasource.maxPoolPreparedStatementPerConnectionSize}")
//	private int maxPoolPreparedStatementPerConnectionSize;
//
//	@Value("${spring.datasource.filters}")
//	private String filters;
//
//	@Value("{spring.datasource.connectionProperties}")
//	private String connectionProperties;
//
//	
////	@Bean
////	@Primary
////	@ConfigurationProperties("app.datasource")
////	public DataSourceProperties firstDataSourceProperties() {
////		System.out.println("~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~");
////		DataSourceProperties da=new DataSourceProperties();
////	    return  da;
////	}
//	
////	@Bean(initMethod = "init", destroyMethod = "close") // 声明其为Bean实例
////	@Primary // 在同样的DataSource中，首先使用被标注的DataSource
////	public DataSource dataSource() {
////		DruidDataSource datasource = new DruidDataSource();
////
////		datasource.setUrl(this.dbUrl);
////		datasource.setUsername(username);
////		datasource.setPassword(password);
////		datasource.setDriverClassName(driverClassName);
////
////		// configuration
////		datasource.setInitialSize(initialSize);
////		datasource.setMinIdle(minIdle);
////		datasource.setMaxActive(maxActive);
////		datasource.setMaxWait(maxWait);
////		datasource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);
////		datasource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);
////		datasource.setValidationQuery(validationQuery);
////		datasource.setTestWhileIdle(testWhileIdle);
////		datasource.setTestOnBorrow(testOnBorrow);
////		datasource.setTestOnReturn(testOnReturn);
////		datasource.setPoolPreparedStatements(poolPreparedStatements);
////		datasource.setMaxPoolPreparedStatementPerConnectionSize(maxPoolPreparedStatementPerConnectionSize);
////		try {
////			datasource.setFilters(filters);
////			log.info("数据源--->"+datasource);
////		} catch (SQLException e) {
////			log.error("druid configuration initialization filter", e);
////		}
////		datasource.setConnectionProperties(connectionProperties);
////
////		return datasource;
////	}

	@Bean
	public ServletRegistrationBean druidServlet() {
		ServletRegistrationBean reg = new ServletRegistrationBean();
		reg.setServlet(new StatViewServlet());
		reg.addUrlMappings("/druid/*");
		reg.addInitParameter("allow", ""); // 白名单
		return reg;
	}

	@Bean
	public FilterRegistrationBean filterRegistrationBean() {
		FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean();
		filterRegistrationBean.setFilter(new WebStatFilter());
		filterRegistrationBean.addUrlPatterns("/*");
		filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");
		filterRegistrationBean.addInitParameter("profileEnable", "true");
		filterRegistrationBean.addInitParameter("principalCookieName", "USER_COOKIE");
		filterRegistrationBean.addInitParameter("principalSessionName", "USER_SESSION");
		filterRegistrationBean.addInitParameter("DruidWebStatFilter", "/*");
		return filterRegistrationBean;
	}
}
